
import pymysql

db=pymysql.connect(host='localhost',
                   port=3306,
                   user='root',
                   passwd='111111',
                   charset='utf8',
                   db='test')
cursor=db.cursor()
cursor.execute('''create table if not exists job(
                    `job_id` int auto_increment primary key,
                    `job_name` varchar(40),
                    `job_sal` int,
                    `company_name` varchar(30),
                    `job_place` varchar(10),
                    `job_exp` varchar(10),
                    `job_education` varchar(10))''')
cursor.execute('show tables')
print(cursor.fetchall())